<%-- 
    Document   : hallticketstatus
    Created on : Apr 14, 2012, 10:20:29 PM
    Author     : Vishwakarma
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try{
   Connection con=Dbconn.getConn();
   Statement st=con.createStatement();
   String   sql="SELECT college.clgid,student.username,photo,name,dob,clgname,email,student.status,job_applied.hallticketstatus  FROM student,college,job_applied where student.clgid=college.clgid and student.username=job_applied.username and college.clgid='"+session.getAttribute("username")+"' and student.status='Verified'";
   ResultSet rs=st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="center" valign="middle">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;"> View Candidate's HallTicket Status</span></td>
                </tr>
                <tr>
                    <td height="10" align="center" valign="middle" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue" style="color:#000066;font-weight:bold" align="center">
                                <td width="28" height="42" valign="middle" class="subjeading" style="background-color: skyblue">#</td>
                                <td width="130" valign="middle" class="subjeading" style="background-color: skyblue">Photo</td>
                              <td width="165" valign="middle" class="subjeading" style="background-color: skyblue"> Name</td>
                              <td width="149" valign="middle" class="subjeading" style="background-color: skyblue">Date Of Birth</td>
                              <td width="149" valign="middle" class="subjeading" style="background-color: skyblue">College</td>
                              <td width="180" valign="middle" class="subjeading" style="background-color: skyblue">Hallticket Status</td>
                              <td width="190" valign="middle" class="subjeading" style="background-color: skyblue">Action</td>
                          </tr>

                            <%
                                int i=0;
                                while (rs.next()) { i++;
                            %>
                            <tr class="greybg"  style="font-weight:bold" align="center">
                                <td height="84"  valign="middle" ><%=i%></td>
                                <td  valign="middle" style="padding-bottom: 17px"><img src="../src/getpic.jsp?id=<%=rs.getString("username")%>&table=student&col=photo&pk_col=username" width="71" height="63" border="0" /></td>
                                <td  valign="middle"><%= rs.getString("name")%></td>
                                <td  valign="middle"><%=rs.getString("dob")%></td>
                                <td  valign="middle"><%=rs.getString("clgname")%></td>
                                <td  valign="middle">
                                    <%
                                    if(rs.getString("hallticketstatus")!=null && rs.getString("hallticketstatus").equalsIgnoreCase("Verified"))
                                    out.println("<font color='green'><strong>Verified</strong></font>");
                                    else
                                        out.println("<font color='red'><strong>Not Verified</strong></font>");
                                    %>
                              </td>
                                <td  valign="middle">
                                <a href="myresumes.jsp" title="View Student Profile"><input id="submit" name="submit" type="submit" value="View Profile" class="button2" style="width:120px; height:40px;"></a>

                           </tr>
                          
                           
<%}%>

<tr align="center">
                <td width="28" height="30" align="center" valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="130"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="165"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="149"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="149"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
				<td width="180"  valign="middle" class="subjeading" style="background-color: skyblue"></td>
                <td width="190"  valign="middle" class="subjeading" style="background-color: skyblue">&nbsp;</td>
                          </tr>
                  </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%}catch(Exception e){
out.println("<font color=\"black\">"+e+"</font>");
}%>
<a href="http://apycom.com/"></a>